﻿CREATE PROCEDURE [dbo].[usp_get_pending_requests]

AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	SELECT [ID], [Description], [EndpointValue], [BindingType], [TransportType],
		[TransportLocation], [UDDIContactName], [UDDIEmail], [UDDIUserType],
		[BiztalkApplication], [EndpointName], [Status], [ModifiedBy], [ModifiedDate], [Category],
		[TargetNamespace], [MessageExchangePattern], [JaxRPCResponse], 
		[ServiceAction], [CacheTimeOut], [RequestAction], [BusinessProvider], [ServiceName]
	FROM EndPoints
	Where Status = 'Pending'
END
